[dbo].[BAECartBillingGetAllByUser]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartBillingGetAllByUser

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UserID	varchar(32)	32

SQL Script

create procedure [dbo].[BAECartBillingGetAllByUser] @UserID as
varchar(32)
AS
    SELECT *
    FROM CartBilling cb
    INNER JOIN CartItem ci on ci.CartItemID = cb.CartItemId
    WHERE ci.UserID = @UserID ORDER BY cb.Title;

GO

Uses

[dbo].[CartBilling]
[dbo].[CartItem]
dbo